Chapter 2-4: Files and Fields

Files Record Protection Option

The Record Protection overlay, shown below, displays when you select the record protection option from the Files/Fields screen. The features in this overlay allow you to prevent users from accessing, modifying or deleting records or record keys.

Files Record Protection Overlay

These fields appear on the Record Protection Overlay:

The Delete Protection field allows you to designate a logic or numeric field for record delete protection. A logic field with a value of 'yes' , or a numeric field with a non-zero value, signals to APPX to prevent the record it belongs to from being deleted during data entry. The same field can be designated as both Delete Protection and Key Protection. Protection is only provided within an input process during Live Operations (see Operational Phase). This field can be used to prevent the creation of orphan records by prohibiting the deletion of records referenced by other records anywhere in a database. You must explicitly maintain the value in this field.

The Key Protection field allows you to designate a logic or numeric field for record key protection. A logic field with a value of 'yes' , or a numeric field with a non-zero value, signals to APPX to prevent the primary key for that record from being changed during data entry. The same field can be designated as both Delete Protection and Key Protection.. Protection is only provided within an input process during Live Operations (see Operational Phase). This field can be used to maintain the integrity of a database by prohibiting the modification of keys referenced by other records anywhere in the database. You must explicitly maintain the value in this field.

The Record Access field allows you to designate a four-character alphanumeric field for security code. All record accesses upon this file within APPX processes check the contents of this field for access class. If the user does not have rights to the security code stored in this field for the desired record, APPX responds as if the record is not on file. The value in this field must be maintained by the designer and must be four numeric characters. If blank, there are no restrictions.

Application Design Manual                                         "Powered by Appx Software"

1009

©2006 By APPX Software, Inc. All Rights Reserved